Overview
Brought to you by YData
Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 37496 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 2650 |
| Duplicate rows (%) | 7.1% |
| Total size in memory | 32.9 MiB |
| Average record size in memory | 920.4 B |
Variable types
| Categorical | 17 |
|---|---|
| Numeric | 13 |
| Text | 1 |
| DateTime | 1 |
hotel has constant value "City Hotel" | Constant |
arrival_date_year has constant value "2016" | Constant |
| Dataset has 2650 (7.1%) duplicate rows | Duplicates |
arrival_date_month is highly overall correlated with arrival_date_week_number | High correlation |
arrival_date_week_number is highly overall correlated with arrival_date_month | High correlation |
assigned_room_type is highly overall correlated with reserved_room_type | High correlation |
cancellation_ratio is highly overall correlated with previous_cancellations | High correlation |
deposit_type is highly overall correlated with is_canceled | High correlation |
distribution_channel is highly overall correlated with market_segment | High correlation |
is_canceled is highly overall correlated with deposit_type and 1 other fields | High correlation |
is_repeated_guest is highly overall correlated with previous_bookings_not_canceled | High correlation |
market_segment is highly overall correlated with distribution_channel | High correlation |
previous_bookings_not_canceled is highly overall correlated with is_repeated_guest | High correlation |
previous_cancellations is highly overall correlated with cancellation_ratio | High correlation |
reservation_status is highly overall correlated with is_canceled | High correlation |
reserved_room_type is highly overall correlated with assigned_room_type | High correlation |
stays_in_week_nights is highly overall correlated with total_stay | High correlation |
stays_in_weekend_nights is highly overall correlated with total_stay | High correlation |
total_stay is highly overall correlated with stays_in_week_nights and 1 other fields | High correlation |
adults is highly imbalanced (53.2%) | Imbalance |
children is highly imbalanced (77.9%) | Imbalance |
babies is highly imbalanced (97.9%) | Imbalance |
meal is highly imbalanced (53.9%) | Imbalance |
distribution_channel is highly imbalanced (66.1%) | Imbalance |
is_repeated_guest is highly imbalanced (86.8%) | Imbalance |
reserved_room_type is highly imbalanced (62.0%) | Imbalance |
assigned_room_type is highly imbalanced (55.3%) | Imbalance |
deposit_type is highly imbalanced (60.3%) | Imbalance |
customer_type is highly imbalanced (61.1%) | Imbalance |
required_car_parking_spaces is highly imbalanced (90.0%) | Imbalance |
previous_bookings_not_canceled is highly skewed (γ1 = 20.69045505) | Skewed |
lead_time has 1255 (3.3%) zeros | Zeros |
stays_in_weekend_nights has 18014 (48.0%) zeros | Zeros |
stays_in_week_nights has 2366 (6.3%) zeros | Zeros |
previous_cancellations has 36039 (96.1%) zeros | Zeros |
previous_bookings_not_canceled has 36742 (98.0%) zeros | Zeros |
booking_changes has 32735 (87.3%) zeros | Zeros |
days_in_waiting_list has 34846 (92.9%) zeros | Zeros |
total_of_special_requests has 22139 (59.0%) zeros | Zeros |
cancellation_ratio has 36039 (96.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-24 18:59:32.016900 |
|---|---|
| Analysis finished | 2025-01-24 19:00:14.166307 |
| Duration | 42.15 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
hotel
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| City Hotel |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | City Hotel |
|---|---|
| 2nd row | City Hotel |
| 3rd row | City Hotel |
| 4th row | City Hotel |
| 5th row | City Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 37496 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| city | 37496 | |
| hotel | 37496 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 74992 | |
| C | 37496 | |
| i | 37496 | |
| y | 37496 | |
| 37496 | ||
| H | 37496 | |
| o | 37496 | |
| e | 37496 | |
| l | 37496 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 74992 | |
| C | 37496 | |
| i | 37496 | |
| y | 37496 | |
| 37496 | ||
| H | 37496 | |
| o | 37496 | |
| e | 37496 | |
| l | 37496 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 74992 | |
| C | 37496 | |
| i | 37496 | |
| y | 37496 | |
| 37496 | ||
| H | 37496 | |
| o | 37496 | |
| e | 37496 | |
| l | 37496 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 74992 | |
| C | 37496 | |
| i | 37496 | |
| y | 37496 | |
| 37496 | ||
| H | 37496 | |
| o | 37496 | |
| e | 37496 | |
| l | 37496 |
is_canceled
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 22177 | |
| 1 | 15319 |
lead_time
Real number (ℝ)
Zeros
| Distinct | 394 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.31603 |
| Minimum | 0 |
|---|---|
| Maximum | 626 |
| Zeros | 1255 |
| Zeros (%) | 3.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 24 |
| median | 73 |
| Q3 | 163 |
| 95-th percentile | 323 |
| Maximum | 626 |
| Range | 626 |
| Interquartile range (IQR) | 139 |
Descriptive statistics
| Standard deviation | 109.72858 |
|---|---|
| Coefficient of variation (CV) | 1.0037739 |
| Kurtosis | 1.5776421 |
| Mean | 109.31603 |
| Median Absolute Deviation (MAD) | 59 |
| Skewness | 1.3489356 |
| Sum | 4098914 |
| Variance | 12040.36 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1255 | 3.3% |
| 1 | 957 | 2.6% |
| 2 | 585 | 1.6% |
| 4 | 544 | 1.5% |
| 3 | 515 | 1.4% |
| 5 | 469 | 1.3% |
| 6 | 411 | 1.1% |
| 7 | 374 | 1.0% |
| 8 | 362 | 1.0% |
| 37 | 316 | 0.8% |
| Other values (384) | 31708 |
| Value | Count | Frequency (%) |
| 0 | 1255 | |
| 1 | 957 | |
| 2 | 585 | |
| 3 | 515 | |
| 4 | 544 | |
| 5 | 469 | 1.3% |
| 6 | 411 | 1.1% |
| 7 | 374 | 1.0% |
| 8 | 362 | 1.0% |
| 9 | 315 | 0.8% |
| Value | Count | Frequency (%) |
| 626 | 30 | |
| 605 | 30 | |
| 538 | 17 | |
| 531 | 17 | |
| 524 | 17 | |
| 517 | 17 | |
| 510 | 17 | |
| 503 | 17 | |
| 496 | 17 | |
| 489 | 17 |
arrival_date_year
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| 2016 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2016 |
| 5th row | 2016 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 37496 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2016 | 37496 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 37496 | |
| 0 | 37496 | |
| 1 | 37496 | |
| 6 | 37496 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 149984 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 37496 | |
| 0 | 37496 | |
| 1 | 37496 | |
| 6 | 37496 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 149984 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 37496 | |
| 0 | 37496 | |
| 1 | 37496 | |
| 6 | 37496 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 149984 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 37496 | |
| 0 | 37496 | |
| 1 | 37496 | |
| 6 | 37496 |
arrival_date_month
Categorical
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.3 MiB |
| October | |
|---|---|
| June | |
| September | |
| May | |
| April | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.0341103 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | October |
|---|---|
| 2nd row | February |
| 3rd row | February |
| 4th row | February |
| 5th row | April |
Common Values
| Value | Count | Frequency (%) |
| October | 4154 | |
| June | 3880 | |
| September | 3824 | |
| May | 3607 | |
| April | 3510 | |
| August | 3348 | |
| July | 3080 | |
| November | 3053 | |
| March | 2990 | |
| December | 2425 | |
| Other values (2) | 3625 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| october | 4154 | |
| june | 3880 | |
| september | 3824 | |
| may | 3607 | |
| april | 3510 | |
| august | 3348 | |
| july | 3080 | |
| november | 3053 | |
| march | 2990 | |
| december | 2425 | |
| Other values (2) | 3625 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 35200 | |
| r | 25894 | 11.4% |
| u | 17281 | 7.6% |
| b | 15769 | 7.0% |
| a | 11534 | 5.1% |
| t | 11326 | 5.0% |
| y | 10312 | 4.6% |
| c | 9569 | 4.2% |
| m | 9302 | 4.1% |
| J | 8272 | 3.7% |
| Other values (16) | 71796 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 226255 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 35200 | |
| r | 25894 | 11.4% |
| u | 17281 | 7.6% |
| b | 15769 | 7.0% |
| a | 11534 | 5.1% |
| t | 11326 | 5.0% |
| y | 10312 | 4.6% |
| c | 9569 | 4.2% |
| m | 9302 | 4.1% |
| J | 8272 | 3.7% |
| Other values (16) | 71796 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 226255 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 35200 | |
| r | 25894 | 11.4% |
| u | 17281 | 7.6% |
| b | 15769 | 7.0% |
| a | 11534 | 5.1% |
| t | 11326 | 5.0% |
| y | 10312 | 4.6% |
| c | 9569 | 4.2% |
| m | 9302 | 4.1% |
| J | 8272 | 3.7% |
| Other values (16) | 71796 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 226255 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 35200 | |
| r | 25894 | 11.4% |
| u | 17281 | 7.6% |
| b | 15769 | 7.0% |
| a | 11534 | 5.1% |
| t | 11326 | 5.0% |
| y | 10312 | 4.6% |
| c | 9569 | 4.2% |
| m | 9302 | 4.1% |
| J | 8272 | 3.7% |
| Other values (16) | 71796 |
arrival_date_week_number
Real number (ℝ)
High correlation
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.863105 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 18 |
| median | 29 |
| Q3 | 41 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 13.630266 |
|---|---|
| Coefficient of variation (CV) | 0.47223836 |
| Kurtosis | -1.0864238 |
| Mean | 28.863105 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.072247581 |
| Sum | 1082251 |
| Variance | 185.78414 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 1117 | 3.0% |
| 42 | 1103 | 2.9% |
| 40 | 1004 | 2.7% |
| 45 | 963 | 2.6% |
| 38 | 950 | 2.5% |
| 21 | 943 | 2.5% |
| 44 | 913 | 2.4% |
| 23 | 908 | 2.4% |
| 24 | 902 | 2.4% |
| 43 | 887 | 2.4% |
| Other values (43) | 27806 |
| Value | Count | Frequency (%) |
| 1 | 138 | 0.4% |
| 2 | 187 | 0.5% |
| 3 | 228 | 0.6% |
| 4 | 368 | |
| 5 | 371 | |
| 6 | 352 | |
| 7 | 473 | |
| 8 | 723 | |
| 9 | 552 | |
| 10 | 697 |
| Value | Count | Frequency (%) |
| 53 | 725 | |
| 52 | 391 | |
| 51 | 350 | 0.9% |
| 50 | 602 | |
| 49 | 615 | |
| 48 | 614 | |
| 47 | 639 | |
| 46 | 813 | |
| 45 | 963 | |
| 44 | 913 |
arrival_date_day_of_month
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.889108 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7685032 |
|---|---|
| Coefficient of variation (CV) | 0.55185622 |
| Kurtosis | -1.1847787 |
| Mean | 15.889108 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.023669617 |
| Sum | 595778 |
| Variance | 76.886649 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 17 | 1469 | 3.9% |
| 28 | 1450 | 3.9% |
| 20 | 1437 | 3.8% |
| 13 | 1426 | 3.8% |
| 19 | 1379 | 3.7% |
| 21 | 1359 | 3.6% |
| 26 | 1320 | 3.5% |
| 7 | 1308 | 3.5% |
| 2 | 1303 | 3.5% |
| 6 | 1273 | 3.4% |
| Other values (21) | 23772 |
| Value | Count | Frequency (%) |
| 1 | 1139 | |
| 2 | 1303 | |
| 3 | 1155 | |
| 4 | 1189 | |
| 5 | 1165 | |
| 6 | 1273 | |
| 7 | 1308 | |
| 8 | 1207 | |
| 9 | 1147 | |
| 10 | 1019 |
| Value | Count | Frequency (%) |
| 31 | 568 | 1.5% |
| 30 | 1226 | |
| 29 | 1199 | |
| 28 | 1450 | |
| 27 | 1214 | |
| 26 | 1320 | |
| 25 | 1145 | |
| 24 | 1229 | |
| 23 | 1011 | |
| 22 | 1147 |
stays_in_weekend_nights
Real number (ℝ)
High correlation Zeros
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.78155003 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 18014 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.87759561 |
|---|---|
| Coefficient of variation (CV) | 1.1228911 |
| Kurtosis | 2.5960196 |
| Mean | 0.78155003 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.0507976 |
| Sum | 29305 |
| Variance | 0.77017406 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 0 | 18014 | |
| 1 | 10410 | |
| 2 | 8695 | |
| 3 | 157 | 0.4% |
| 4 | 146 | 0.4% |
| 5 | 30 | 0.1% |
| 6 | 25 | 0.1% |
| 8 | 11 | < 0.1% |
| 7 | 5 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 18014 | |
| 1 | 10410 | |
| 2 | 8695 | |
| 3 | 157 | 0.4% |
| 4 | 146 | 0.4% |
| 5 | 30 | 0.1% |
| 6 | 25 | 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 11 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 3 | < 0.1% |
| 8 | 11 | < 0.1% |
| 7 | 5 | < 0.1% |
| 6 | 25 | 0.1% |
| 5 | 30 | 0.1% |
| 4 | 146 | 0.4% |
| 3 | 157 | 0.4% |
| 2 | 8695 | |
| 1 | 10410 | |
| 0 | 18014 |
stays_in_week_nights
Real number (ℝ)
High correlation Zeros
| Distinct | 24 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.199968 |
| Minimum | 0 |
|---|---|
| Maximum | 25 |
| Zeros | 2366 |
| Zeros (%) | 6.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.456656 |
|---|---|
| Coefficient of variation (CV) | 0.66212599 |
| Kurtosis | 20.149885 |
| Mean | 2.199968 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.5224895 |
| Sum | 82490 |
| Variance | 2.1218466 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 2 | 12541 | |
| 1 | 9711 | |
| 3 | 7808 | |
| 4 | 2910 | 7.8% |
| 0 | 2366 | 6.3% |
| 5 | 1623 | 4.3% |
| 6 | 189 | 0.5% |
| 7 | 94 | 0.3% |
| 10 | 76 | 0.2% |
| 8 | 71 | 0.2% |
| Other values (14) | 107 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 2366 | 6.3% |
| 1 | 9711 | |
| 2 | 12541 | |
| 3 | 7808 | |
| 4 | 2910 | 7.8% |
| 5 | 1623 | 4.3% |
| 6 | 189 | 0.5% |
| 7 | 94 | 0.3% |
| 8 | 71 | 0.2% |
| 9 | 37 | 0.1% |
| Value | Count | Frequency (%) |
| 25 | 1 | < 0.1% |
| 22 | 3 | < 0.1% |
| 21 | 6 | |
| 20 | 4 | |
| 19 | 2 | < 0.1% |
| 18 | 5 | |
| 17 | 3 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 8 | |
| 14 | 8 |
adults
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 2444 |
| 0 | 137 |
| 4 | 16 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 27406 | |
| 1 | 7493 | 20.0% |
| 3 | 2444 | 6.5% |
| 0 | 137 | 0.4% |
| 4 | 16 | < 0.1% |
children
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 | 1590 |
| 2 | 1050 |
| 3 | 18 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34838 | |
| 1 | 1590 | 4.2% |
| 2 | 1050 | 2.8% |
| 3 | 18 | < 0.1% |
babies
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 | 164 |
| 2 | 4 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000267 |
| Min length | 1 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 37327 | |
| 1 | 164 | 0.4% |
| 2 | 4 | < 0.1% |
| 10 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 37327 | |
| 1 | 164 | 0.4% |
| 2 | 4 | < 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 37328 | |
| 1 | 165 | 0.4% |
| 2 | 4 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37497 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 37328 | |
| 1 | 165 | 0.4% |
| 2 | 4 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37497 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 37328 | |
| 1 | 165 | 0.4% |
| 2 | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37497 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 37328 | |
| 1 | 165 | 0.4% |
| 2 | 4 | < 0.1% |
meal
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| BB | |
|---|---|
| SC | |
| HB | 2696 |
| FB | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 29847 | |
| SC | 4952 | 13.2% |
| HB | 2696 | 7.2% |
| FB | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 29847 | |
| sc | 4952 | 13.2% |
| hb | 2696 | 7.2% |
| fb | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 62391 | |
| S | 4952 | 6.6% |
| C | 4952 | 6.6% |
| H | 2696 | 3.6% |
| F | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 74992 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 62391 | |
| S | 4952 | 6.6% |
| C | 4952 | 6.6% |
| H | 2696 | 3.6% |
| F | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 74992 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 62391 | |
| S | 4952 | 6.6% |
| C | 4952 | 6.6% |
| H | 2696 | 3.6% |
| F | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 74992 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 62391 | |
| S | 4952 | 6.6% |
| C | 4952 | 6.6% |
| H | 2696 | 3.6% |
| F | 1 | < 0.1% |
country
Text
| Distinct | 145 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.993626 |
| Min length | 2 |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | ESP |
|---|---|
| 2nd row | PRT |
| 3rd row | PRT |
| 4th row | BRA |
| 5th row | PRT |
| Value | Count | Frequency (%) |
| prt | 13534 | |
| fra | 4416 | 11.8% |
| deu | 3166 | 8.4% |
| gbr | 2393 | 6.4% |
| esp | 2261 | 6.0% |
| ita | 1713 | 4.6% |
| bel | 946 | 2.5% |
| bra | 875 | 2.3% |
| nld | 846 | 2.3% |
| usa | 737 | 2.0% |
| Other values (135) | 6609 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 23293 | |
| P | 16311 | |
| T | 16132 | |
| A | 9062 | 8.1% |
| E | 7649 | 6.8% |
| U | 5411 | 4.8% |
| F | 4602 | 4.1% |
| B | 4415 | 3.9% |
| D | 4309 | 3.8% |
| S | 4160 | 3.7% |
| Other values (18) | 16905 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 112249 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 23293 | |
| P | 16311 | |
| T | 16132 | |
| A | 9062 | 8.1% |
| E | 7649 | 6.8% |
| U | 5411 | 4.8% |
| F | 4602 | 4.1% |
| B | 4415 | 3.9% |
| D | 4309 | 3.8% |
| S | 4160 | 3.7% |
| Other values (18) | 16905 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 112249 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 23293 | |
| P | 16311 | |
| T | 16132 | |
| A | 9062 | 8.1% |
| E | 7649 | 6.8% |
| U | 5411 | 4.8% |
| F | 4602 | 4.1% |
| B | 4415 | 3.9% |
| D | 4309 | 3.8% |
| S | 4160 | 3.7% |
| Other values (18) | 16905 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 112249 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 23293 | |
| P | 16311 | |
| T | 16132 | |
| A | 9062 | 8.1% |
| E | 7649 | 6.8% |
| U | 5411 | 4.8% |
| F | 4602 | 4.1% |
| B | 4415 | 3.9% |
| D | 4309 | 3.8% |
| S | 4160 | 3.7% |
| Other values (18) | 16905 |
market_segment
Categorical
High correlation
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 1616 |
| Other values (2) | 137 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.3613452 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Online TA |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | Online TA |
| 5th row | Offline TA/TO |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 19579 | |
| Offline TA/TO | 8874 | |
| Groups | 4632 | 12.4% |
| Direct | 2658 | 7.1% |
| Corporate | 1616 | 4.3% |
| Aviation | 125 | 0.3% |
| Complementary | 12 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 19579 | |
| ta | 19579 | |
| offline | 8874 | |
| ta/to | 8874 | |
| groups | 4632 | 7.0% |
| direct | 2658 | 4.0% |
| corporate | 1616 | 2.5% |
| aviation | 125 | 0.2% |
| complementary | 12 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 48169 | |
| O | 37327 | |
| T | 37327 | |
| e | 32751 | |
| i | 31361 | |
| A | 28578 | |
| l | 28465 | |
| 28453 | ||
| f | 17748 | 5.1% |
| r | 10534 | 3.0% |
| Other values (14) | 50300 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 351013 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 48169 | |
| O | 37327 | |
| T | 37327 | |
| e | 32751 | |
| i | 31361 | |
| A | 28578 | |
| l | 28465 | |
| 28453 | ||
| f | 17748 | 5.1% |
| r | 10534 | 3.0% |
| Other values (14) | 50300 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 351013 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 48169 | |
| O | 37327 | |
| T | 37327 | |
| e | 32751 | |
| i | 31361 | |
| A | 28578 | |
| l | 28465 | |
| 28453 | ||
| f | 17748 | 5.1% |
| r | 10534 | 3.0% |
| Other values (14) | 50300 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 351013 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 48169 | |
| O | 37327 | |
| T | 37327 | |
| e | 32751 | |
| i | 31361 | |
| A | 28578 | |
| l | 28465 | |
| 28453 | ||
| f | 17748 | 5.1% |
| r | 10534 | 3.0% |
| Other values (14) | 50300 |
distribution_channel
Categorical
High correlation Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| TA/TO | |
|---|---|
| Direct | 2750 |
| Corporate | 1806 |
| GDS | 101 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.2606145 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TA/TO |
|---|---|
| 2nd row | Direct |
| 3rd row | Direct |
| 4th row | TA/TO |
| 5th row | TA/TO |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 32839 | |
| Direct | 2750 | 7.3% |
| Corporate | 1806 | 4.8% |
| GDS | 101 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 32839 | |
| direct | 2750 | 7.3% |
| corporate | 1806 | 4.8% |
| gds | 101 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 65678 | |
| A | 32839 | |
| / | 32839 | |
| O | 32839 | |
| r | 6362 | 3.2% |
| e | 4556 | 2.3% |
| t | 4556 | 2.3% |
| o | 3612 | 1.8% |
| D | 2851 | 1.4% |
| i | 2750 | 1.4% |
| Other values (6) | 8370 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 197252 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 65678 | |
| A | 32839 | |
| / | 32839 | |
| O | 32839 | |
| r | 6362 | 3.2% |
| e | 4556 | 2.3% |
| t | 4556 | 2.3% |
| o | 3612 | 1.8% |
| D | 2851 | 1.4% |
| i | 2750 | 1.4% |
| Other values (6) | 8370 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 197252 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 65678 | |
| A | 32839 | |
| / | 32839 | |
| O | 32839 | |
| r | 6362 | 3.2% |
| e | 4556 | 2.3% |
| t | 4556 | 2.3% |
| o | 3612 | 1.8% |
| D | 2851 | 1.4% |
| i | 2750 | 1.4% |
| Other values (6) | 8370 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 197252 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 65678 | |
| A | 32839 | |
| / | 32839 | |
| O | 32839 | |
| r | 6362 | 3.2% |
| e | 4556 | 2.3% |
| t | 4556 | 2.3% |
| o | 3612 | 1.8% |
| D | 2851 | 1.4% |
| i | 2750 | 1.4% |
| Other values (6) | 8370 | 4.2% |
is_repeated_guest
Categorical
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 | 685 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36811 | |
| 1 | 685 | 1.8% |
previous_cancellations
Real number (ℝ)
High correlation Zeros
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.056272669 |
| Minimum | 0 |
|---|---|
| Maximum | 13 |
| Zeros | 36039 |
| Zeros (%) | 96.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 13 |
| Range | 13 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4645383 |
|---|---|
| Coefficient of variation (CV) | 8.2551318 |
| Kurtosis | 456.75577 |
| Mean | 0.056272669 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.264955 |
| Sum | 2110 |
| Variance | 0.21579583 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0 | 36039 | |
| 1 | 1329 | 3.5% |
| 3 | 38 | 0.1% |
| 11 | 33 | 0.1% |
| 2 | 24 | 0.1% |
| 5 | 11 | < 0.1% |
| 13 | 11 | < 0.1% |
| 6 | 7 | < 0.1% |
| 4 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 36039 | |
| 1 | 1329 | 3.5% |
| 2 | 24 | 0.1% |
| 3 | 38 | 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 11 | < 0.1% |
| 6 | 7 | < 0.1% |
| 11 | 33 | 0.1% |
| 13 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 13 | 11 | < 0.1% |
| 11 | 33 | 0.1% |
| 6 | 7 | < 0.1% |
| 5 | 11 | < 0.1% |
| 4 | 4 | < 0.1% |
| 3 | 38 | 0.1% |
| 2 | 24 | 0.1% |
| 1 | 1329 | 3.5% |
| 0 | 36039 |
previous_bookings_not_canceled
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13385428 |
| Minimum | 0 |
|---|---|
| Maximum | 58 |
| Zeros | 36742 |
| Zeros (%) | 98.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 58 |
| Range | 58 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.6818984 |
|---|---|
| Coefficient of variation (CV) | 12.565145 |
| Kurtosis | 518.78492 |
| Mean | 0.13385428 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.690455 |
| Sum | 5019 |
| Variance | 2.8287821 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 36742 | |
| 1 | 263 | 0.7% |
| 2 | 92 | 0.2% |
| 3 | 62 | 0.2% |
| 4 | 62 | 0.2% |
| 5 | 47 | 0.1% |
| 6 | 31 | 0.1% |
| 7 | 18 | < 0.1% |
| 8 | 18 | < 0.1% |
| 9 | 16 | < 0.1% |
| Other values (49) | 145 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 36742 | |
| 1 | 263 | 0.7% |
| 2 | 92 | 0.2% |
| 3 | 62 | 0.2% |
| 4 | 62 | 0.2% |
| 5 | 47 | 0.1% |
| 6 | 31 | 0.1% |
| 7 | 18 | < 0.1% |
| 8 | 18 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 58 | 1 | |
| 57 | 1 | |
| 56 | 1 | |
| 55 | 1 | |
| 54 | 1 | |
| 53 | 1 | |
| 52 | 1 | |
| 51 | 1 | |
| 50 | 1 | |
| 49 | 1 |
reserved_room_type
Categorical
High correlation Imbalance
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| A | |
|---|---|
| D | |
| F | 901 |
| B | 641 |
| E | 575 |
| Other values (2) | 201 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| A | 29192 | |
| D | 5986 | 16.0% |
| F | 901 | 2.4% |
| B | 641 | 1.7% |
| E | 575 | 1.5% |
| G | 194 | 0.5% |
| C | 7 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 29192 | |
| d | 5986 | 16.0% |
| f | 901 | 2.4% |
| b | 641 | 1.7% |
| e | 575 | 1.5% |
| g | 194 | 0.5% |
| c | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 29192 | |
| D | 5986 | 16.0% |
| F | 901 | 2.4% |
| B | 641 | 1.7% |
| E | 575 | 1.5% |
| G | 194 | 0.5% |
| C | 7 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 29192 | |
| D | 5986 | 16.0% |
| F | 901 | 2.4% |
| B | 641 | 1.7% |
| E | 575 | 1.5% |
| G | 194 | 0.5% |
| C | 7 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 29192 | |
| D | 5986 | 16.0% |
| F | 901 | 2.4% |
| B | 641 | 1.7% |
| E | 575 | 1.5% |
| G | 194 | 0.5% |
| C | 7 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 29192 | |
| D | 5986 | 16.0% |
| F | 901 | 2.4% |
| B | 641 | 1.7% |
| E | 575 | 1.5% |
| G | 194 | 0.5% |
| C | 7 | < 0.1% |
assigned_room_type
Categorical
High correlation Imbalance
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| A | |
|---|---|
| D | |
| B | 1227 |
| F | 997 |
| E | 938 |
| Other values (3) | 456 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| A | 26505 | |
| D | 7373 | 19.7% |
| B | 1227 | 3.3% |
| F | 997 | 2.7% |
| E | 938 | 2.5% |
| G | 309 | 0.8% |
| K | 74 | 0.2% |
| C | 73 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 26505 | |
| d | 7373 | 19.7% |
| b | 1227 | 3.3% |
| f | 997 | 2.7% |
| e | 938 | 2.5% |
| g | 309 | 0.8% |
| k | 74 | 0.2% |
| c | 73 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 26505 | |
| D | 7373 | 19.7% |
| B | 1227 | 3.3% |
| F | 997 | 2.7% |
| E | 938 | 2.5% |
| G | 309 | 0.8% |
| K | 74 | 0.2% |
| C | 73 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 26505 | |
| D | 7373 | 19.7% |
| B | 1227 | 3.3% |
| F | 997 | 2.7% |
| E | 938 | 2.5% |
| G | 309 | 0.8% |
| K | 74 | 0.2% |
| C | 73 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 26505 | |
| D | 7373 | 19.7% |
| B | 1227 | 3.3% |
| F | 997 | 2.7% |
| E | 938 | 2.5% |
| G | 309 | 0.8% |
| K | 74 | 0.2% |
| C | 73 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 26505 | |
| D | 7373 | 19.7% |
| B | 1227 | 3.3% |
| F | 997 | 2.7% |
| E | 938 | 2.5% |
| G | 309 | 0.8% |
| K | 74 | 0.2% |
| C | 73 | 0.2% |
booking_changes
Real number (ℝ)
Zeros
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.18716663 |
| Minimum | 0 |
|---|---|
| Maximum | 17 |
| Zeros | 32735 |
| Zeros (%) | 87.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.61036224 |
|---|---|
| Coefficient of variation (CV) | 3.2610633 |
| Kurtosis | 89.777524 |
| Mean | 0.18716663 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.6067359 |
| Sum | 7018 |
| Variance | 0.37254206 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 0 | 32735 | |
| 1 | 3272 | 8.7% |
| 2 | 1094 | 2.9% |
| 3 | 237 | 0.6% |
| 4 | 90 | 0.2% |
| 5 | 24 | 0.1% |
| 6 | 15 | < 0.1% |
| 7 | 11 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| Other values (5) | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 32735 | |
| 1 | 3272 | 8.7% |
| 2 | 1094 | 2.9% |
| 3 | 237 | 0.6% |
| 4 | 90 | 0.2% |
| 5 | 24 | 0.1% |
| 6 | 15 | < 0.1% |
| 7 | 11 | < 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 2 | < 0.1% |
| 13 | 3 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 4 | < 0.1% |
| 8 | 5 | < 0.1% |
| 7 | 11 | |
| 6 | 15 | |
| 5 | 24 |
deposit_type
Categorical
High correlation Imbalance
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 3 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 31587 | |
| Non Refund | 5906 | 15.8% |
| Refundable | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 31587 | |
| deposit | 31587 | |
| non | 5906 | 7.9% |
| refund | 5906 | 7.9% |
| refundable | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 69080 | |
| e | 37499 | |
| N | 37493 | |
| 37493 | ||
| s | 31587 | |
| i | 31587 | |
| t | 31587 | |
| p | 31587 | |
| D | 31587 | |
| n | 11815 | 3.2% |
| Other values (7) | 23645 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 69080 | |
| e | 37499 | |
| N | 37493 | |
| 37493 | ||
| s | 31587 | |
| i | 31587 | |
| t | 31587 | |
| p | 31587 | |
| D | 31587 | |
| n | 11815 | 3.2% |
| Other values (7) | 23645 | 6.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 69080 | |
| e | 37499 | |
| N | 37493 | |
| 37493 | ||
| s | 31587 | |
| i | 31587 | |
| t | 31587 | |
| p | 31587 | |
| D | 31587 | |
| n | 11815 | 3.2% |
| Other values (7) | 23645 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 374960 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 69080 | |
| e | 37499 | |
| N | 37493 | |
| 37493 | ||
| s | 31587 | |
| i | 31587 | |
| t | 31587 | |
| p | 31587 | |
| D | 31587 | |
| n | 11815 | 3.2% |
| Other values (7) | 23645 | 6.3% |
days_in_waiting_list
Real number (ℝ)
Zeros
| Distinct | 86 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.5678206 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 34846 |
| Zeros (%) | 92.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 39 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 28.674532 |
|---|---|
| Coefficient of variation (CV) | 5.1500459 |
| Kurtosis | 76.951094 |
| Mean | 5.5678206 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.8856975 |
| Sum | 208771 |
| Variance | 822.22876 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 34846 | |
| 39 | 225 | 0.6% |
| 44 | 136 | 0.4% |
| 31 | 123 | 0.3% |
| 35 | 94 | 0.3% |
| 46 | 87 | 0.2% |
| 63 | 80 | 0.2% |
| 45 | 65 | 0.2% |
| 38 | 64 | 0.2% |
| 41 | 63 | 0.2% |
| Other values (76) | 1713 | 4.6% |
| Value | Count | Frequency (%) |
| 0 | 34846 | |
| 1 | 5 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 59 | 0.2% |
| 4 | 20 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 13 | < 0.1% |
| 10 | 27 | 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 | |
| 224 | 10 | < 0.1% |
| 223 | 60 | |
| 215 | 21 | 0.1% |
| 207 | 15 | < 0.1% |
| 193 | 1 | < 0.1% |
customer_type
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 177 |
| Group | 56 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.183833 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient-Party |
| 3rd row | Transient-Party |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 29798 | |
| Transient-Party | 7465 | 19.9% |
| Contract | 177 | 0.5% |
| Group | 56 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 29798 | |
| transient-party | 7465 | 19.9% |
| contract | 177 | 0.5% |
| group | 56 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 74703 | |
| t | 45082 | |
| r | 44961 | |
| a | 44905 | |
| T | 37263 | |
| s | 37263 | |
| i | 37263 | |
| e | 37263 | |
| y | 7465 | 2.0% |
| - | 7465 | 2.0% |
| Other values (7) | 8220 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 381853 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 74703 | |
| t | 45082 | |
| r | 44961 | |
| a | 44905 | |
| T | 37263 | |
| s | 37263 | |
| i | 37263 | |
| e | 37263 | |
| y | 7465 | 2.0% |
| - | 7465 | 2.0% |
| Other values (7) | 8220 | 2.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 381853 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 74703 | |
| t | 45082 | |
| r | 44961 | |
| a | 44905 | |
| T | 37263 | |
| s | 37263 | |
| i | 37263 | |
| e | 37263 | |
| y | 7465 | 2.0% |
| - | 7465 | 2.0% |
| Other values (7) | 8220 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 381853 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 74703 | |
| t | 45082 | |
| r | 44961 | |
| a | 44905 | |
| T | 37263 | |
| s | 37263 | |
| i | 37263 | |
| e | 37263 | |
| y | 7465 | 2.0% |
| - | 7465 | 2.0% |
| Other values (7) | 8220 | 2.2% |
adr
Real number (ℝ)
| Distinct | 3921 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 105.09422 |
| Minimum | 21 |
|---|---|
| Maximum | 451.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 21 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 80 |
| median | 99.48 |
| Q3 | 122.65 |
| 95-th percentile | 168.3 |
| Maximum | 451.5 |
| Range | 430.5 |
| Interquartile range (IQR) | 42.65 |
Descriptive statistics
| Standard deviation | 33.840805 |
|---|---|
| Coefficient of variation (CV) | 0.32200442 |
| Kurtosis | 2.7761707 |
| Mean | 105.09422 |
| Median Absolute Deviation (MAD) | 20.52 |
| Skewness | 1.2021844 |
| Sum | 3940613 |
| Variance | 1145.2001 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 75 | 1226 | 3.3% |
| 65 | 1069 | 2.9% |
| 62 | 993 | 2.6% |
| 110 | 783 | 2.1% |
| 120 | 777 | 2.1% |
| 90 | 766 | 2.0% |
| 95 | 731 | 1.9% |
| 100 | 688 | 1.8% |
| 115 | 669 | 1.8% |
| 80 | 598 | 1.6% |
| Other values (3911) | 29196 |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 22.5 | 2 | < 0.1% |
| 23 | 1 | < 0.1% |
| 26.35 | 1 | < 0.1% |
| 31 | 11 | |
| 32.5 | 4 | < 0.1% |
| 32.85 | 1 | < 0.1% |
| 35 | 2 | < 0.1% |
| 37.33 | 1 | < 0.1% |
| 37.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 451.5 | 1 | |
| 375.5 | 1 | |
| 365 | 1 | |
| 349.63 | 1 | |
| 345 | 1 | |
| 332.57 | 1 | |
| 316 | 1 | |
| 314.1 | 1 | |
| 309.5 | 1 | |
| 306 | 2 |
required_car_parking_spaces
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.1 MiB |
| 0 | |
|---|---|
| 1 | 1164 |
| 3 | 1 |
| 2 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 37496 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 36330 | |
| 1 | 1164 | 3.1% |
| 3 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
total_of_special_requests
Real number (ℝ)
Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54896522 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 22139 |
| Zeros (%) | 59.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.75632374 |
|---|---|
| Coefficient of variation (CV) | 1.3777261 |
| Kurtosis | 1.4133124 |
| Mean | 0.54896522 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3144796 |
| Sum | 20584 |
| Variance | 0.5720256 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 22139 | |
| 1 | 10887 | |
| 2 | 3802 | 10.1% |
| 3 | 588 | 1.6% |
| 4 | 71 | 0.2% |
| 5 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 22139 | |
| 1 | 10887 | |
| 2 | 3802 | 10.1% |
| 3 | 588 | 1.6% |
| 4 | 71 | 0.2% |
| 5 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 4 | 71 | 0.2% |
| 3 | 588 | 1.6% |
| 2 | 3802 | 10.1% |
| 1 | 10887 | |
| 0 | 22139 |
reservation_status
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.3 MiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 544 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.5769415 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Canceled |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 22177 | |
| Canceled | 14775 | |
| No-Show | 544 | 1.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 22177 | |
| canceled | 14775 | |
| no-show | 544 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 51727 | |
| C | 36952 | |
| c | 36952 | |
| h | 22721 | |
| - | 22721 | |
| u | 22177 | |
| t | 22177 | |
| O | 22177 | |
| k | 22177 | |
| a | 14775 | 4.6% |
| Other values (7) | 47045 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 321601 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 51727 | |
| C | 36952 | |
| c | 36952 | |
| h | 22721 | |
| - | 22721 | |
| u | 22177 | |
| t | 22177 | |
| O | 22177 | |
| k | 22177 | |
| a | 14775 | 4.6% |
| Other values (7) | 47045 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 321601 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 51727 | |
| C | 36952 | |
| c | 36952 | |
| h | 22721 | |
| - | 22721 | |
| u | 22177 | |
| t | 22177 | |
| O | 22177 | |
| k | 22177 | |
| a | 14775 | 4.6% |
| Other values (7) | 47045 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 321601 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 51727 | |
| C | 36952 | |
| c | 36952 | |
| h | 22721 | |
| - | 22721 | |
| u | 22177 | |
| t | 22177 | |
| O | 22177 | |
| k | 22177 | |
| a | 14775 | 4.6% |
| Other values (7) | 47045 |
| Distinct | 438 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 293.1 KiB |
| Minimum | 2015-01-12 00:00:00 |
|---|---|
| Maximum | 2017-08-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
total_stay
Real number (ℝ)
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.981518 |
| Minimum | 1 |
|---|---|
| Maximum | 34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 34 |
| Range | 33 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.8653585 |
|---|---|
| Coefficient of variation (CV) | 0.62564053 |
| Kurtosis | 28.655002 |
| Mean | 2.981518 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.3631401 |
| Sum | 111795 |
| Variance | 3.4795624 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 3 | 10389 | |
| 2 | 9669 | |
| 1 | 6772 | |
| 4 | 5629 | |
| 5 | 2404 | 6.4% |
| 6 | 1033 | 2.8% |
| 7 | 990 | 2.6% |
| 8 | 181 | 0.5% |
| 10 | 108 | 0.3% |
| 9 | 98 | 0.3% |
| Other values (21) | 223 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 6772 | |
| 2 | 9669 | |
| 3 | 10389 | |
| 4 | 5629 | |
| 5 | 2404 | 6.4% |
| 6 | 1033 | 2.8% |
| 7 | 990 | 2.6% |
| 8 | 181 | 0.5% |
| 9 | 98 | 0.3% |
| 10 | 108 | 0.3% |
| Value | Count | Frequency (%) |
| 34 | 1 | < 0.1% |
| 30 | 3 | < 0.1% |
| 29 | 8 | |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 3 | < 0.1% |
| 25 | 1 | < 0.1% |
| 24 | 4 | |
| 23 | 2 | < 0.1% |
| 22 | 2 | < 0.1% |
cancellation_ratio
Real number (ℝ)
High correlation Zeros
| Distinct | 103 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.03516661 |
| Minimum | 0 |
|---|---|
| Maximum | 0.99999923 |
| Zeros | 36039 |
| Zeros (%) | 96.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0.99999923 |
| Range | 0.99999923 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.18230625 |
|---|---|
| Coefficient of variation (CV) | 5.1840723 |
| Kurtosis | 23.779931 |
| Mean | 0.03516661 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.0670277 |
| Sum | 1318.6072 |
| Variance | 0.033235569 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 36039 | |
| 0.9999900001 | 1256 | 3.3% |
| 0.9285707653 | 10 | < 0.1% |
| 0.1666663889 | 9 | < 0.1% |
| 0.1428569388 | 8 | < 0.1% |
| 0.3055554707 | 8 | < 0.1% |
| 0.249999375 | 8 | < 0.1% |
| 0.1999996 | 8 | < 0.1% |
| 0.7333328444 | 7 | < 0.1% |
| 0.4999975 | 7 | < 0.1% |
| Other values (93) | 136 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 36039 | |
| 0.03333332222 | 1 | < 0.1% |
| 0.03448274673 | 1 | < 0.1% |
| 0.05263155125 | 1 | < 0.1% |
| 0.05555552469 | 1 | < 0.1% |
| 0.05882349481 | 1 | < 0.1% |
| 0.06249996094 | 2 | < 0.1% |
| 0.06382977365 | 1 | < 0.1% |
| 0.06521737713 | 1 | < 0.1% |
| 0.06666662222 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.9999992308 | 1 | < 0.1% |
| 0.9999990909 | 3 | < 0.1% |
| 0.9999983333 | 6 | < 0.1% |
| 0.9999966667 | 1 | < 0.1% |
| 0.9999900001 | 1256 | |
| 0.9285707653 | 10 | < 0.1% |
| 0.9166659028 | 1 | < 0.1% |
| 0.749998125 | 1 | < 0.1% |
| 0.7333328444 | 7 | < 0.1% |
| 0.6874995703 | 5 | < 0.1% |
Interactions
Correlations
| adr | adults | arrival_date_day_of_month | arrival_date_month | arrival_date_week_number | assigned_room_type | babies | booking_changes | cancellation_ratio | children | customer_type | days_in_waiting_list | deposit_type | distribution_channel | is_canceled | is_repeated_guest | lead_time | market_segment | meal | previous_bookings_not_canceled | previous_cancellations | required_car_parking_spaces | reservation_status | reserved_room_type | stays_in_week_nights | stays_in_weekend_nights | total_of_special_requests | total_stay | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adr | 1.000 | 0.183 | -0.008 | 0.125 | 0.155 | 0.268 | 0.047 | 0.021 | -0.138 | 0.307 | 0.092 | -0.122 | 0.229 | 0.091 | 0.151 | 0.091 | -0.189 | 0.193 | 0.109 | -0.125 | -0.139 | 0.064 | 0.107 | 0.319 | 0.011 | 0.028 | 0.234 | 0.025 |
| adults | 0.183 | 1.000 | 0.026 | 0.106 | 0.102 | 0.267 | 0.019 | 0.021 | 0.046 | 0.192 | 0.091 | 0.033 | 0.082 | 0.180 | 0.056 | 0.209 | 0.092 | 0.188 | 0.080 | 0.068 | 0.039 | 0.015 | 0.065 | 0.319 | 0.050 | 0.059 | 0.115 | 0.045 |
| arrival_date_day_of_month | -0.008 | 0.026 | 1.000 | 0.085 | 0.022 | 0.011 | 0.011 | 0.021 | 0.014 | 0.023 | 0.034 | 0.032 | 0.066 | 0.036 | 0.045 | 0.022 | 0.009 | 0.060 | 0.039 | -0.012 | 0.014 | 0.009 | 0.036 | 0.016 | -0.011 | 0.007 | -0.003 | -0.006 |
| arrival_date_month | 0.125 | 0.106 | 0.085 | 1.000 | 0.816 | 0.041 | 0.017 | 0.024 | 0.085 | 0.088 | 0.092 | 0.109 | 0.095 | 0.071 | 0.081 | 0.072 | 0.170 | 0.108 | 0.072 | 0.028 | 0.049 | 0.047 | 0.090 | 0.061 | 0.046 | 0.049 | 0.079 | 0.050 |
| arrival_date_week_number | 0.155 | 0.102 | 0.022 | 0.816 | 1.000 | 0.037 | 0.016 | 0.008 | -0.158 | 0.081 | 0.103 | -0.134 | 0.103 | 0.067 | 0.082 | 0.075 | 0.174 | 0.096 | 0.063 | -0.005 | -0.157 | 0.044 | 0.087 | 0.055 | 0.049 | 0.033 | 0.123 | 0.052 |
| assigned_room_type | 0.268 | 0.267 | 0.011 | 0.041 | 0.037 | 1.000 | 0.042 | 0.030 | 0.039 | 0.418 | 0.099 | 0.043 | 0.188 | 0.130 | 0.176 | 0.029 | 0.087 | 0.146 | 0.117 | 0.022 | 0.000 | 0.046 | 0.130 | 0.704 | 0.039 | 0.036 | 0.089 | 0.040 |
| babies | 0.047 | 0.019 | 0.011 | 0.017 | 0.016 | 0.042 | 1.000 | 0.034 | 0.000 | 0.023 | 0.012 | 0.000 | 0.019 | 0.032 | 0.029 | 0.002 | 0.016 | 0.037 | 0.044 | 0.000 | 0.000 | 0.015 | 0.020 | 0.049 | 0.000 | 0.000 | 0.055 | 0.000 |
| booking_changes | 0.021 | 0.021 | 0.021 | 0.024 | 0.008 | 0.030 | 0.034 | 1.000 | -0.057 | 0.043 | 0.034 | -0.043 | 0.059 | 0.034 | 0.072 | 0.000 | -0.026 | 0.030 | 0.000 | 0.039 | -0.056 | 0.015 | 0.053 | 0.022 | 0.020 | 0.029 | 0.046 | 0.033 |
| cancellation_ratio | -0.138 | 0.046 | 0.014 | 0.085 | -0.158 | 0.039 | 0.000 | -0.057 | 1.000 | 0.026 | 0.075 | 0.340 | 0.247 | 0.115 | 0.223 | 0.379 | 0.099 | 0.125 | 0.045 | 0.153 | 1.000 | 0.022 | 0.163 | 0.034 | -0.028 | -0.076 | -0.125 | -0.065 |
| children | 0.307 | 0.192 | 0.023 | 0.088 | 0.081 | 0.418 | 0.023 | 0.043 | 0.026 | 1.000 | 0.049 | 0.029 | 0.084 | 0.053 | 0.034 | 0.031 | 0.058 | 0.117 | 0.050 | 0.000 | 0.000 | 0.041 | 0.025 | 0.460 | 0.022 | 0.030 | 0.093 | 0.034 |
| customer_type | 0.092 | 0.091 | 0.034 | 0.092 | 0.103 | 0.099 | 0.012 | 0.034 | 0.075 | 0.049 | 1.000 | 0.107 | 0.150 | 0.074 | 0.187 | 0.075 | 0.113 | 0.223 | 0.151 | 0.014 | 0.021 | 0.052 | 0.136 | 0.111 | 0.031 | 0.050 | 0.074 | 0.045 |
| days_in_waiting_list | -0.122 | 0.033 | 0.032 | 0.109 | -0.134 | 0.043 | 0.000 | -0.043 | 0.340 | 0.029 | 0.107 | 1.000 | 0.208 | 0.045 | 0.156 | 0.026 | 0.276 | 0.136 | 0.083 | -0.015 | 0.337 | 0.017 | 0.115 | 0.044 | 0.030 | -0.097 | -0.187 | -0.022 |
| deposit_type | 0.229 | 0.082 | 0.066 | 0.095 | 0.103 | 0.188 | 0.019 | 0.059 | 0.247 | 0.084 | 0.150 | 0.208 | 1.000 | 0.107 | 0.517 | 0.057 | 0.384 | 0.444 | 0.118 | 0.013 | 0.022 | 0.054 | 0.377 | 0.156 | 0.073 | 0.104 | 0.252 | 0.074 |
| distribution_channel | 0.091 | 0.180 | 0.036 | 0.071 | 0.067 | 0.130 | 0.032 | 0.034 | 0.115 | 0.053 | 0.074 | 0.045 | 0.107 | 1.000 | 0.164 | 0.453 | 0.135 | 0.735 | 0.083 | 0.175 | 0.108 | 0.074 | 0.124 | 0.164 | 0.071 | 0.065 | 0.063 | 0.057 |
| is_canceled | 0.151 | 0.056 | 0.045 | 0.081 | 0.082 | 0.176 | 0.029 | 0.072 | 0.223 | 0.034 | 0.187 | 0.156 | 0.517 | 0.164 | 1.000 | 0.087 | 0.302 | 0.300 | 0.049 | 0.050 | 0.035 | 0.149 | 1.000 | 0.074 | 0.049 | 0.071 | 0.393 | 0.053 |
| is_repeated_guest | 0.091 | 0.209 | 0.022 | 0.072 | 0.075 | 0.029 | 0.002 | 0.000 | 0.379 | 0.031 | 0.075 | 0.026 | 0.057 | 0.453 | 0.087 | 1.000 | 0.131 | 0.479 | 0.050 | 0.518 | 0.377 | 0.129 | 0.089 | 0.039 | 0.068 | 0.051 | 0.025 | 0.043 |
| lead_time | -0.189 | 0.092 | 0.009 | 0.170 | 0.174 | 0.087 | 0.016 | -0.026 | 0.099 | 0.058 | 0.113 | 0.276 | 0.384 | 0.135 | 0.302 | 0.131 | 1.000 | 0.246 | 0.149 | -0.148 | 0.097 | 0.051 | 0.227 | 0.086 | 0.219 | 0.005 | -0.147 | 0.185 |
| market_segment | 0.193 | 0.188 | 0.060 | 0.108 | 0.096 | 0.146 | 0.037 | 0.030 | 0.125 | 0.117 | 0.223 | 0.136 | 0.444 | 0.735 | 0.300 | 0.479 | 0.246 | 1.000 | 0.222 | 0.131 | 0.081 | 0.095 | 0.224 | 0.182 | 0.091 | 0.117 | 0.201 | 0.096 |
| meal | 0.109 | 0.080 | 0.039 | 0.072 | 0.063 | 0.117 | 0.044 | 0.000 | 0.045 | 0.050 | 0.151 | 0.083 | 0.118 | 0.083 | 0.049 | 0.050 | 0.149 | 0.222 | 1.000 | 0.014 | 0.010 | 0.005 | 0.042 | 0.124 | 0.040 | 0.014 | 0.065 | 0.020 |
| previous_bookings_not_canceled | -0.125 | 0.068 | -0.012 | 0.028 | -0.005 | 0.022 | 0.000 | 0.039 | 0.153 | 0.000 | 0.014 | -0.015 | 0.013 | 0.175 | 0.050 | 0.518 | -0.148 | 0.131 | 0.014 | 1.000 | 0.164 | 0.039 | 0.037 | 0.028 | -0.114 | -0.048 | 0.007 | -0.127 |
| previous_cancellations | -0.139 | 0.039 | 0.014 | 0.049 | -0.157 | 0.000 | 0.000 | -0.056 | 1.000 | 0.000 | 0.021 | 0.337 | 0.022 | 0.108 | 0.035 | 0.377 | 0.097 | 0.081 | 0.010 | 0.164 | 1.000 | 0.018 | 0.024 | 0.000 | -0.029 | -0.075 | -0.124 | -0.066 |
| required_car_parking_spaces | 0.064 | 0.015 | 0.009 | 0.047 | 0.044 | 0.046 | 0.015 | 0.015 | 0.022 | 0.041 | 0.052 | 0.017 | 0.054 | 0.074 | 0.149 | 0.129 | 0.051 | 0.095 | 0.005 | 0.039 | 0.018 | 1.000 | 0.105 | 0.046 | 0.009 | 0.000 | 0.057 | 0.000 |
| reservation_status | 0.107 | 0.065 | 0.036 | 0.090 | 0.087 | 0.130 | 0.020 | 0.053 | 0.163 | 0.025 | 0.136 | 0.115 | 0.377 | 0.124 | 1.000 | 0.089 | 0.227 | 0.224 | 0.042 | 0.037 | 0.024 | 0.105 | 1.000 | 0.055 | 0.097 | 0.101 | 0.280 | 0.100 |
| reserved_room_type | 0.319 | 0.319 | 0.016 | 0.061 | 0.055 | 0.704 | 0.049 | 0.022 | 0.034 | 0.460 | 0.111 | 0.044 | 0.156 | 0.164 | 0.074 | 0.039 | 0.086 | 0.182 | 0.124 | 0.028 | 0.000 | 0.046 | 0.055 | 1.000 | 0.053 | 0.046 | 0.088 | 0.054 |
| stays_in_week_nights | 0.011 | 0.050 | -0.011 | 0.046 | 0.049 | 0.039 | 0.000 | 0.020 | -0.028 | 0.022 | 0.031 | 0.030 | 0.073 | 0.071 | 0.049 | 0.068 | 0.219 | 0.091 | 0.040 | -0.114 | -0.029 | 0.009 | 0.097 | 0.053 | 1.000 | 0.013 | 0.039 | 0.809 |
| stays_in_weekend_nights | 0.028 | 0.059 | 0.007 | 0.049 | 0.033 | 0.036 | 0.000 | 0.029 | -0.076 | 0.030 | 0.050 | -0.097 | 0.104 | 0.065 | 0.071 | 0.051 | 0.005 | 0.117 | 0.014 | -0.048 | -0.075 | 0.000 | 0.101 | 0.046 | 0.013 | 1.000 | 0.100 | 0.559 |
| total_of_special_requests | 0.234 | 0.115 | -0.003 | 0.079 | 0.123 | 0.089 | 0.055 | 0.046 | -0.125 | 0.093 | 0.074 | -0.187 | 0.252 | 0.063 | 0.393 | 0.025 | -0.147 | 0.201 | 0.065 | 0.007 | -0.124 | 0.057 | 0.280 | 0.088 | 0.039 | 0.100 | 1.000 | 0.095 |
| total_stay | 0.025 | 0.045 | -0.006 | 0.050 | 0.052 | 0.040 | 0.000 | 0.033 | -0.065 | 0.034 | 0.045 | -0.022 | 0.074 | 0.057 | 0.053 | 0.043 | 0.185 | 0.096 | 0.020 | -0.127 | -0.066 | 0.000 | 0.100 | 0.054 | 0.809 | 0.559 | 0.095 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | total_stay | cancellation_ratio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | City Hotel | 0 | 0 | 2016 | October | 44 | 29 | 1 | 1 | 2 | 0 | 0 | BB | ESP | Online TA | TA/TO | 1 | 0 | 0 | A | A | 2 | No Deposit | 0 | Transient | 21.00 | 0 | 4 | Check-Out | 31/10/2016 | 2 | 0.0 |
| 1 | City Hotel | 0 | 0 | 2016 | February | 6 | 3 | 0 | 2 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | B | B | 1 | No Deposit | 0 | Transient-Party | 22.50 | 1 | 0 | Check-Out | 05/02/2016 | 2 | 0.0 |
| 2 | City Hotel | 0 | 0 | 2016 | February | 6 | 3 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | B | B | 1 | No Deposit | 0 | Transient-Party | 22.50 | 0 | 0 | Check-Out | 05/02/2016 | 2 | 0.0 |
| 3 | City Hotel | 0 | 57 | 2016 | February | 7 | 8 | 1 | 2 | 2 | 0 | 0 | BB | BRA | Online TA | TA/TO | 0 | 0 | 0 | B | B | 0 | No Deposit | 0 | Transient | 23.00 | 0 | 0 | Check-Out | 11/02/2016 | 3 | 0.0 |
| 4 | City Hotel | 1 | 31 | 2016 | April | 17 | 23 | 2 | 4 | 2 | 1 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 26.35 | 0 | 0 | Canceled | 23/03/2016 | 6 | 0.0 |
| 5 | City Hotel | 0 | 3 | 2016 | February | 9 | 26 | 0 | 1 | 2 | 0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | A | 2 | No Deposit | 0 | Transient-Party | 31.00 | 0 | 1 | Check-Out | 27/02/2016 | 1 | 0.0 |
| 6 | City Hotel | 0 | 16 | 2016 | February | 9 | 26 | 0 | 1 | 1 | 0 | 0 | BB | ESP | Corporate | Corporate | 0 | 0 | 0 | A | A | 1 | No Deposit | 0 | Transient-Party | 31.00 | 0 | 1 | Check-Out | 27/02/2016 | 1 | 0.0 |
| 7 | City Hotel | 0 | 16 | 2016 | February | 9 | 26 | 0 | 1 | 1 | 0 | 0 | BB | ESP | Corporate | Corporate | 0 | 0 | 0 | A | E | 1 | No Deposit | 0 | Transient-Party | 31.00 | 0 | 2 | Check-Out | 27/02/2016 | 1 | 0.0 |
| 8 | City Hotel | 0 | 16 | 2016 | February | 9 | 26 | 0 | 1 | 1 | 0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | A | 1 | No Deposit | 0 | Transient-Party | 31.00 | 0 | 1 | Check-Out | 27/02/2016 | 1 | 0.0 |
| 9 | City Hotel | 0 | 3 | 2016 | February | 9 | 26 | 0 | 1 | 1 | 0 | 0 | BB | ESP | Corporate | Corporate | 0 | 0 | 0 | A | A | 1 | No Deposit | 0 | Transient-Party | 31.00 | 0 | 1 | Check-Out | 27/02/2016 | 1 | 0.0 |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | total_stay | cancellation_ratio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37486 | City Hotel | 0 | 4 | 2016 | July | 28 | 8 | 1 | 2 | 2 | 2 | 0 | BB | MEX | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 0 | Transient | 306.00 | 0 | 3 | Check-Out | 11/07/2016 | 3 | 0.0 |
| 37487 | City Hotel | 0 | 206 | 2016 | August | 32 | 5 | 0 | 1 | 2 | 2 | 0 | HB | GBR | Direct | Direct | 0 | 0 | 0 | G | G | 1 | No Deposit | 0 | Transient | 309.50 | 1 | 0 | Check-Out | 06/08/2016 | 1 | 0.0 |
| 37488 | City Hotel | 0 | 57 | 2016 | December | 53 | 30 | 1 | 2 | 2 | 0 | 0 | HB | FRA | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 314.10 | 0 | 0 | Check-Out | 02/01/2017 | 3 | 0.0 |
| 37489 | City Hotel | 0 | 6 | 2016 | August | 33 | 13 | 0 | 1 | 2 | 2 | 0 | HB | IRL | Online TA | TA/TO | 0 | 0 | 0 | F | F | 0 | No Deposit | 0 | Transient | 316.00 | 1 | 0 | Check-Out | 14/08/2016 | 1 | 0.0 |
| 37490 | City Hotel | 0 | 28 | 2016 | June | 23 | 2 | 0 | 3 | 2 | 2 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | F | G | 0 | No Deposit | 0 | Transient | 332.57 | 0 | 1 | Check-Out | 05/06/2016 | 3 | 0.0 |
| 37491 | City Hotel | 0 | 21 | 2016 | September | 37 | 7 | 0 | 4 | 3 | 1 | 0 | HB | PRT | Direct | Direct | 0 | 0 | 0 | G | G | 0 | No Deposit | 0 | Transient | 345.00 | 1 | 0 | Check-Out | 11/09/2016 | 4 | 0.0 |
| 37492 | City Hotel | 0 | 43 | 2016 | December | 53 | 29 | 0 | 3 | 2 | 2 | 0 | HB | BEL | Online TA | TA/TO | 0 | 0 | 0 | F | F | 0 | No Deposit | 0 | Transient | 349.63 | 0 | 1 | Check-Out | 01/01/2017 | 3 | 0.0 |
| 37493 | City Hotel | 0 | 173 | 2016 | July | 31 | 25 | 1 | 2 | 2 | 1 | 0 | HB | FRA | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | D | 0 | No Deposit | 0 | Transient-Party | 365.00 | 0 | 1 | Check-Out | 28/07/2016 | 3 | 0.0 |
| 37494 | City Hotel | 0 | 21 | 2016 | December | 53 | 30 | 0 | 2 | 3 | 0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 375.50 | 0 | 0 | Check-Out | 01/01/2017 | 2 | 0.0 |
| 37495 | City Hotel | 0 | 81 | 2016 | December | 53 | 31 | 1 | 1 | 2 | 2 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | E | E | 1 | No Deposit | 0 | Transient-Party | 451.50 | 0 | 4 | Check-Out | 02/01/2017 | 2 | 0.0 |
Duplicate rows
Most frequently occurring
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | total_stay | cancellation_ratio | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2483 | City Hotel | 1 | 277 | 2016 | November | 46 | 7 | 1 | 2 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0 | Transient | 100.0 | 0 | 0 | Canceled | 04/04/2016 | 3 | 0.00000 | 180 |
| 1917 | City Hotel | 1 | 68 | 2016 | February | 8 | 17 | 0 | 2 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 0 | Transient | 75.0 | 0 | 0 | Canceled | 06/01/2016 | 2 | 0.99999 | 150 |
| 2326 | City Hotel | 1 | 188 | 2016 | June | 25 | 15 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 39 | Transient | 130.0 | 0 | 0 | Canceled | 18/01/2016 | 2 | 0.00000 | 109 |
| 2234 | City Hotel | 1 | 158 | 2016 | May | 22 | 24 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 31 | Transient | 130.0 | 0 | 0 | Canceled | 18/01/2016 | 2 | 0.00000 | 101 |
| 1929 | City Hotel | 1 | 71 | 2016 | June | 25 | 14 | 0 | 3 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0 | Transient | 120.0 | 0 | 0 | Canceled | 27/04/2016 | 3 | 0.00000 | 89 |
| 2262 | City Hotel | 1 | 166 | 2016 | November | 45 | 1 | 0 | 3 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0 | Transient | 110.0 | 0 | 0 | Canceled | 13/07/2016 | 3 | 0.00000 | 85 |
| 2524 | City Hotel | 1 | 304 | 2016 | November | 45 | 3 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0 | Transient | 89.0 | 0 | 0 | Canceled | 01/02/2016 | 3 | 0.00000 | 85 |
| 2525 | City Hotel | 1 | 305 | 2016 | November | 45 | 4 | 1 | 2 | 2 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 0 | Transient | 89.0 | 0 | 0 | Canceled | 01/02/2016 | 3 | 0.00000 | 85 |
| 1786 | City Hotel | 1 | 37 | 2016 | October | 42 | 13 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient-Party | 105.0 | 0 | 0 | Canceled | 06/09/2016 | 3 | 0.00000 | 84 |
| 2043 | City Hotel | 1 | 99 | 2016 | February | 8 | 19 | 0 | 1 | 2 | 0 | 0 | BB | PRT | Corporate | Corporate | 0 | 1 | 0 | A | A | 0 | No Deposit | 0 | Transient-Party | 80.0 | 0 | 0 | Canceled | 22/12/2015 | 1 | 0.99999 | 69 |